using System;
using System.Data;
using System.Data.SqlClient;

public class <OwnerU>_<TableU>DataClass
{

    public static DataTable SelectAll()
    {
        SqlConnection connection = <Database>DataClass.GetConnection();
        string selectProcedure = "[<Owner>].[<TableU>SelectAll]";
        SqlCommand selectCommand = new SqlCommand(selectProcedure, connection);
        selectCommand.CommandType = CommandType.StoredProcedure;
        DataTable dt = new DataTable();
        try
        {
            connection.Open();
            SqlDataReader reader = selectCommand.ExecuteReader();
            if (reader.HasRows) {
                dt.Load(reader); }
            reader.Close();
        }
        catch (SqlException ex)
        {
            throw ex;
        }
        finally
        {
            connection.Close();
        }
        return dt;
    }

    public static <OwnerU>_<TableU>Class Select_Record(<OwnerU>_<TableU>Class cls<OwnerU>_<TableU>Para)
    {
        <OwnerU>_<TableU>Class cls<OwnerU>_<TableU> = new <OwnerU>_<TableU>Class();
        SqlConnection connection = <Database>DataClass.GetConnection();
        string selectProcedure = "[<Owner>].[<TableU>Select]";
        SqlCommand selectCommand = new SqlCommand(selectProcedure, connection);
        selectCommand.CommandType = CommandType.StoredProcedure;
        <If Loop>
           <IsPKey>
        selectCommand.Parameters.AddWithValue("@<FieldU>", cls<OwnerU>_<TableU>Para.<FieldU>);
        </If Loop>
        <If Loop>
           <IsNotPKey>
           <And>
           <IsIdentity>
        selectCommand.Parameters.AddWithValue("@<FieldU>", cls<OwnerU>_<TableU>Para.<FieldU>);
        </If Loop>
        <If Loop>
           <IsNotIdentityCount>
           <And>
           <IsNotPKeyCount>
   	   <And>
           <IsNotText>
           <And>
           <IsNotNText>
           <And>
           <IsNotXML>
        selectCommand.Parameters.AddWithValue("@<FieldU>", cls<OwnerU>_<TableU>Para.<FieldU>);
           <ExitLoop>
        </If Loop>
        try
        {
            connection.Open();
            SqlDataReader reader
                = selectCommand.ExecuteReader(CommandBehavior.SingleRow);
            if (reader.Read())
            {
                <If Loop>
                    <IsNull>
                    <And>
                    <IsNullable>
                    <And>
                    <IsFloat>
                cls<OwnerU>_<TableU>.<FieldU> = reader["<Field>"] is DBNull ? null : (Decimal?)(Double?)reader["<Field>"];
                    <IsNull>
                    <And>
                    <IsNullable>
                    <And>
                    <IsReal>
                cls<OwnerU>_<TableU>.<FieldU> = reader["<Field>"] is DBNull ? null : (Decimal?)(Single?)reader["<Field>"];
                    <IsNull>
                    <And>
                    <IsNullable>
                    <And>
                    <IsNotFloat>
                    <And>
                    <IsNotReal>
                cls<OwnerU>_<TableU>.<FieldU> = reader["<Field>"] is DBNull ? null : (<VBType>?)reader["<Field>"];
                    <IsNull>
                    <And>
                    <IsNotNullable>
                cls<OwnerU>_<TableU>.<FieldU> = reader["<Field>"] is DBNull ? null : reader["<Field>"].ToString();
                    <IsNotNull>
                cls<OwnerU>_<TableU>.<FieldU> = <Convert>(reader["<Field>"]);
                </If Loop>
            }
            else
            {
                cls<OwnerU>_<TableU> = null;
            }
            reader.Close();
        }
        catch (SqlException ex)
        {
            throw ex;
        }
        finally
        {
            connection.Close();
        }
        return cls<OwnerU>_<TableU>;
    }

    public static bool Add(<OwnerU>_<TableU>Class cls<OwnerU>_<TableU>)
    {
        SqlConnection connection = <Database>DataClass.GetConnection();
        string insertProcedure = "[<Owner>].[<TableU>Insert]";
        SqlCommand insertCommand = new SqlCommand(insertProcedure, connection);
        insertCommand.CommandType = CommandType.StoredProcedure;
        <If Loop>
           <IsNotIdentity>
           <And>
           <IsNull>
           <And>
           <IsNullable>
        if (cls<OwnerU>_<TableU>.<FieldU>.HasValue == true) {
            insertCommand.Parameters.AddWithValue("@<FieldU>", cls<OwnerU>_<TableU>.<FieldU>);
        } else {
            insertCommand.Parameters.AddWithValue("@<FieldU>", DBNull.Value); }
           <IsNotIdentity>
           <And>
           <IsNull>
           <And>
           <IsNotNullable>
        if (cls<OwnerU>_<TableU>.<FieldU> != null) {
            insertCommand.Parameters.AddWithValue("@<FieldU>", cls<OwnerU>_<TableU>.<FieldU>);
        } else {
            insertCommand.Parameters.AddWithValue("@<FieldU>", DBNull.Value); }
           <IsNotIdentity>
           <And>
           <IsNotNull>
        insertCommand.Parameters.AddWithValue("@<FieldU>", cls<OwnerU>_<TableU>.<FieldU>);
        </If Loop>
        insertCommand.Parameters.Add("@ReturnValue", System.Data.SqlDbType.Int);
        insertCommand.Parameters["@ReturnValue"].Direction = ParameterDirection.Output;
        try
        {
            connection.Open();
            insertCommand.ExecuteNonQuery();
            int count = System.Convert.ToInt32(insertCommand.Parameters["@ReturnValue"].Value);
            if (count > 0)
            {
                return true;
            }
            else
            {
                return false;
            }
        }
        catch (SqlException ex)
        {
            throw ex;
        }
        finally
        {
            connection.Close();
        }
    }

    public static bool Update(<OwnerU>_<TableU>Class old<OwnerU>_<TableU>Class, 
           <OwnerU>_<TableU>Class new<OwnerU>_<TableU>Class)
    {
        SqlConnection connection = <Database>DataClass.GetConnection();
        string updateProcedure = "[<Owner>].[<TableU>Update]";
        SqlCommand updateCommand = new SqlCommand(updateProcedure, connection);
        updateCommand.CommandType = CommandType.StoredProcedure;
        <If Loop>
           <IsNotIdentity>
           <And>
           <IsNull>
           <And>
           <IsNullable>
        if (new<OwnerU>_<TableU>Class.<FieldU>.HasValue == true) {
            updateCommand.Parameters.AddWithValue("@New<FieldU>", new<OwnerU>_<TableU>Class.<FieldU>);
        } else {
            updateCommand.Parameters.AddWithValue("@New<FieldU>", DBNull.Value); }
           <IsNotIdentity>
           <And>
           <IsNull>
           <And>
           <IsNotNullable>
        if (new<OwnerU>_<TableU>Class.<FieldU> != null) {
            updateCommand.Parameters.AddWithValue("@New<FieldU>", new<OwnerU>_<TableU>Class.<FieldU>);
        } else {
            updateCommand.Parameters.AddWithValue("@New<FieldU>", DBNull.Value); }
           <IsNotIdentity>
           <And>
           <IsNotNull>
        updateCommand.Parameters.AddWithValue("@New<FieldU>", new<OwnerU>_<TableU>Class.<FieldU>);
        </If Loop>
        <If Loop>
           <IsNotText>
           <And>
           <IsNotNText>
           <And>
           <IsNotXML>
           <And>
           <IsNotNull>
        updateCommand.Parameters.AddWithValue("@Old<FieldU>", old<OwnerU>_<TableU>Class.<FieldU>);
           <IsNotText>
           <And>
           <IsNotNText>
           <And>
           <IsNotXML>
           <And>
           <IsNull>
           <And>
           <IsNullable>
        if (old<OwnerU>_<TableU>Class.<FieldU>.HasValue == true) {
            updateCommand.Parameters.AddWithValue("@Old<FieldU>", old<OwnerU>_<TableU>Class.<FieldU>);
        } else {
            updateCommand.Parameters.AddWithValue("@Old<FieldU>", DBNull.Value); }
           <IsNotText>
           <And>
           <IsNotNText>
           <And>
           <IsNotXML>
           <And>
           <IsNull>
           <And>
           <IsNotNullable>
        if (old<OwnerU>_<TableU>Class.<FieldU> != null) {
            updateCommand.Parameters.AddWithValue("@Old<FieldU>", old<OwnerU>_<TableU>Class.<FieldU>);
        } else {
            updateCommand.Parameters.AddWithValue("@Old<FieldU>", DBNull.Value); }
        </If Loop>
        updateCommand.Parameters.Add("@ReturnValue", System.Data.SqlDbType.Int);
        updateCommand.Parameters["@ReturnValue"].Direction = ParameterDirection.Output;
        try
        {
            connection.Open();
            updateCommand.ExecuteNonQuery();
            int count = System.Convert.ToInt32(updateCommand.Parameters["@ReturnValue"].Value);
            if (count > 0)
            {
                return true;
            }
            else
            {
                return false;
            }
        }
        catch (SqlException ex)
        {
            throw ex;
        }
        finally
        {
            connection.Close();
        }
    }

    public static bool Delete(<OwnerU>_<TableU>Class cls<OwnerU>_<TableU>)
    {
        SqlConnection connection = <Database>DataClass.GetConnection();
        string deleteProcedure = "[<Owner>].[<TableU>Delete]";
        SqlCommand deleteCommand = new SqlCommand(deleteProcedure, connection);
        deleteCommand.CommandType = CommandType.StoredProcedure;
        <If Loop>
           <IsNotText>
           <And>
           <IsNotNText>
           <And>
           <IsNotXML>
           <And>
           <IsNotNull>
        deleteCommand.Parameters.AddWithValue("@Old<FieldU>", cls<OwnerU>_<TableU>.<FieldU>);
           <IsNotText>
           <And>
           <IsNotNText>
           <And>
           <IsNotXML>
           <And>
           <IsNull>
           <And>
           <IsNullable>
        if (cls<OwnerU>_<TableU>.<FieldU>.HasValue == true) {
            deleteCommand.Parameters.AddWithValue("@Old<FieldU>", cls<OwnerU>_<TableU>.<FieldU>);
        } else {
            deleteCommand.Parameters.AddWithValue("@Old<FieldU>", DBNull.Value); }
           <IsNotText>
           <And>
           <IsNotNText>
           <And>
           <IsNotXML>
           <And>
           <IsNull>
           <And>
           <IsNotNullable>
        if (cls<OwnerU>_<TableU>.<FieldU> != null) {
            deleteCommand.Parameters.AddWithValue("@Old<FieldU>", cls<OwnerU>_<TableU>.<FieldU>);
        } else {
            deleteCommand.Parameters.AddWithValue("@Old<FieldU>", DBNull.Value); }
        </If Loop>
        deleteCommand.Parameters.Add("@ReturnValue", System.Data.SqlDbType.Int);
        deleteCommand.Parameters["@ReturnValue"].Direction = ParameterDirection.Output;
        try
        {
            connection.Open();
            deleteCommand.ExecuteNonQuery();
            int count = System.Convert.ToInt32(deleteCommand.Parameters["@ReturnValue"].Value);
            if (count > 0)
            {
                return true;
            }
            else
            {
                return false;
            }
        }
        catch (SqlException ex)
        {
            throw ex;
        }
        finally
        {
            connection.Close();
        }
    }
}
